CREATE EXTERNAL TABLE jms_dim.dim_lmdm_threecode_analysis_detail(
   `collect_time` timestamp COMMENT '下单时间',
   `bill_source_name` string COMMENT '运单来源',
   `bill_no` string COMMENT '运单号',
   `agent_code` string COMMENT '代理地区编码',
   `receiver_city_name` string COMMENT '收件省市区',
   `receiver_address` string COMMENT '详细地址',
   `terminal_code` string COMMENT '面单三段码',
   `sign_three_segement_code` string COMMENT '签收三段码',
   `exception_code` int COMMENT '异常编码',
   `exception_name` string COMMENT '异常名称',
   `pick_network_name` string COMMENT '寄件网点',
   `customer_name` string COMMENT '客户名称',
   `sign_network_name` string COMMENT '签收网点',
   `dispatch_staff_name` string COMMENT '签收业务员',
   `sign_time` timestamp COMMENT '签收时间',
   `agent_name` string COMMENT '代理区名称')
 COMMENT '一二段码异常表'
 ROW FORMAT SERDE
   'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
 STORED AS INPUTFORMAT
   'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
 OUTPUTFORMAT
   'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
 LOCATION
   '/dw/hive/jms_dim.db/external/dim_lmdm_threecode_analysis_detail'
TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );